﻿using System;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using OrmSmackdown;
using System.Data;
using System.Data.SqlClient;

namespace OrmSmackdownTests
{
    /// <summary>
    /// Summary description for CrudTests
    /// </summary>
    [TestClass]
    public class CrudTests
    {
        ILogger logger = new Logger();
        IDbConnection db = new SqlConnection(SqlServerDSN);

        public CrudTests()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        private TestContext testContextInstance;

        /// <summary>
        ///Gets or sets the test context which provides
        ///information about and functionality for the current test run.
        ///</summary>
        public TestContext TestContext
        {
            get
            {
                return testContextInstance;
            }
            set
            {
                testContextInstance = value;
            }
        }

        #region Additional test attributes
        //
        // You can use the following additional attributes as you write your tests:
        //
        // Use ClassInitialize to run code before running the first test in the class
        // [ClassInitialize()]
        // public static void MyClassInitialize(TestContext testContext) { }
        //
        // Use ClassCleanup to run code after all tests in a class have run
        // [ClassCleanup()]
        // public static void MyClassCleanup() { }
        //
        // Use TestInitialize to run code before running each test 
        // [TestInitialize()]
        // public void MyTestInitialize() { }
        //
        // Use TestCleanup to run code after each test has run
        // [TestCleanup()]
        // public void MyTestCleanup() { }
        //
        #endregion

        [TestMethod]
        public void TestLinq2Sql()
        {
            using (var crud = new OrmSmackdown.LinqToSql.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);            	
            };
        }

        [TestMethod]
        public void TestEntityFrameworks()
        {
            using (var crud = new OrmSmackdown.EntityFrameworks.Crud("name=SqlSmackDownEntities"))
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        [TestMethod]
        public void TestLightSpeed()
        {
            using (var crud = new OrmSmackdown.LightSpeedORM.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        [TestMethod]
        public void TestNHibernate()
        {
            using (var crud = new OrmSmackdown.NHibernate.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        [TestMethod]
        public void TestLinqToNHibernate()
        {
            using (var crud = new OrmSmackdown.LinqToNHibernate.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        [TestMethod]
        public void TestLLBLGen()
        {
            using (var crud = new OrmSmackdown.LLBLGen.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }


        [TestMethod]
        public void TestSubsonic()
        {
            using (var crud = new OrmSmackdown.SubSonic.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        [TestMethod]
        public void TestAdoDotNet()
        {
            using (var crud = new OrmSmackdown.AdoNet.Crud())
            {
                var tester = new CrudRunner(crud, logger);
                tester.CrudIt(db);
            };
        }

        private static string SqlServerDSN
        {
            get { return System.Configuration.ConfigurationManager.ConnectionStrings["ssdsn"].ConnectionString; }
        }

    }
}
